◀ Prev · Parts · Full · Next ▶

Ebean ORM supports History AS OF and VERSIONS BETWEEN queries on PostgreSQL and MySQL using triggers, history tables and views.

CockroachDB has supported AS OF SYSTEM TIME queries since at least v1.0.7.cite-ref-16[16]cite-ref-17[17]

Wikibooks has a book on the topic of:

Structured Query Language

• SQL

• Slowly changing dimension

• Temporal database

cite-note-11. ↑ citerefpaulley2011Paulley (December 16, 2011), "SQL:2011 is published", IA, Sybase, archived from the original (blog) on July 11, 2012

cite-note-22. ↑ Zemke, Fred. "What's new in SQL:2011 Archived 2013-08-10 at the Wayback Machine". ACM SIGMOD Record 41.1 (2012): 67-73

cite-note-33. ↑ Kulkarni, Krishna, and Jan-Eike Michels. "Temporal features in SQL: 2011 Archived 2012-11-15 at the Wayback Machine". ACM SIGMOD Record 41.3 (2012): 34-43

cite-note-44. ↑ "SAP Help Portal".

cite-note-55. ↑ "SAP Help Portal".

◀ Prev · Parts · Full · Next ▶